/*
 * Copyright (c) 2011 Imre Fazekas.
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions are met:
 *
 *   Redistributions of source code must retain the above copyright notice, this
 *   list of conditions and the following disclaimer.
 *
 *   Redistributions in binary form must reproduce the above copyright notice,
 *   this list of conditions and the following disclaimer in the documentation
 *   and/or other materials provided with the distribution.
 *
 *   Neither the name of the Wit-In Comp Inc. nor the names of its
 *   contributors may be used to endorse or promote products derived from this
 *   software without specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE
 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
 * POSSIBILITY OF SUCH DAMAGE.
 */

package com.acme.creditblue;

import com.vii.brillien.core.component.SuperPresence;
import com.vii.brillien.kernel.BrillienException;
import com.vii.brillien.kernel.annotations.PresenceService;
import com.vii.brillien.kernel.annotations.lifecycle.Resident;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * Service-level Presence type demonstrating how-to realize a background process
 */
@PresenceService( logLevel = PresenceService.INFO, timeMeasure = 2000, periodical = true )
@Resident
public class CreditSuperVision<R> extends SuperPresence<R> {

    private Connection c;

    @Override
    public void plan() throws BrillienException {
        c = getConnection("CustomerDataConnector");
    }
    
    @Override
    protected R innerCall() throws BrillienException {
        log( "Examining accounts..." );
        try { StringBuilder sb = new StringBuilder();
            PreparedStatement st = c.prepareStatement( "SELECT id FROM account where balance < 0" );
            ResultSet s = st.executeQuery();
            while( s.next() ){
                sb.append( " " + s.getLong("id") );
            }
            s.close(); st.close();
            log( "Accounts with negative balance: " + sb.toString() );
        } catch (SQLException e) {
            exceptionLog( CreditSuperVision.class.getName(), "innerCall", e );
        }

        return null;   
    }

}
